Industrial Engineeringcoretheory
DATA ANALYTICS AND VISUALISATION
MIE 2127
Syllabus
- 01Introduction: Functions-logical, summarizing, text, lookup and reference, statistical and financial
- 02Analysis of quantitative data: Tools, analysis for time series data and cross-sectional data using visual analysis and descriptive statistics, data relationship tools
- 03Analysis of qualitative data: dealing with data errors, pivot chart or pivot table reports
- 04Inferential statistical analysis of data: statistical techniques to fit the data-chi square test, z-test and t-test, test of hypothesis, Analysis of variance
- 05Presentation of quantitative data: data classification, data context and data orientation, charts and graphs, macros
- 06Presentation of qualitative data
References
- Dick Kusleika, Data Visualization with Excel Dashboards and Reports, Wiley, 2021
- Hector Guerrero, Excel Data Analysis: Modeling and Simulation, Springer, 2019
- Manisha Nigam, Advanced Analytics with Excel 2019, BPB publications, 2020
- Paul Mcfedries, Excel data analysis for dummies, Wiley, 2022
Credits Structure
3Lecture
0Tutorial
0Practical
3Total